<?xml version="1.0" encoding="UTF-8"?>
<k3Integrationk3Data>
	<data key="currency">
		<description>货币类型</description>
		<sql>
			select * from  t_Currency
		</sql>
		<display_fields></display_fields>
		<search_fields></search_fields>
	</data>
	<data key="exRateType">
		<description>汇率类型</description>
		<sql>
			SELECT * FROM v_BASE_ExRateType
		</sql>
	</data>
	<data key="department">
		<description>费用承担部门、申请部门</description>
		<sql>
			SELECT * FROM t_Department
		</sql>
		<display_fields>@FNAME|部门@</display_fields>
		<search_fields>@FNAME|部门@</search_fields>
	</data>
	<data key="settle">
		<description>支付方式</description>
		<sql>
			select * from  t_Settle
		</sql>
		<display_fields>@FNAME|支付方式@</display_fields>
		<search_fields>@FNAME|支付方式@</search_fields>
	</data>
	<data key="prjFeeItemCode">
		<description>费用项目代码,费用项目名称</description>
		<sql>
			SELECT bb.*,a.FAccountID,a.FName as 'FAccountName',a.FNumber as 'FAccountNumber'
			FROM t_Base_BudgetItem bb,t_Account a
			where bb.FRPAcctID=a.FAccountID
		</sql>
		<display_fields>@FName|费用项目名称@,@FItemId|费用项目代码@</display_fields>
		<search_fields>@FAccountName|费用项目名称@</search_fields>
	</data>
	<data key="prjItemClass">
		<description>核算项目类别</description>
		<sql>
			SELECT FItemClassID,FName,FNumber
			FROM t_ItemClass
			WHERE FItemClassID IN(1,2,3,8)
			UNION
			SELECT convert(int,substring(fkey,13,len(fkey)-12)),fvalue,fdescription
			FROM t_rp_systemprofile
			WHERE fkey LIKE 'FItemClassAP%'
		</sql>
		<display_fields>@FNAME|核算项目类别@,@FNUMBER|核算项目类别代码@</display_fields>
		<search_fields>@FNAME|核算项目类别@</search_fields>
	</data>
	<data key="checkPrjItem">
		<description>核算项目</description>
		<sql>
			SELECT u.FItemClassID,v.FItemID,v.FNumber,v.FName
			FROM t_ItemClass u
			INNER JOIN t_Item v ON u.FItemClassID=v.FItemClassID
		</sql>
		<display_fields>@FNAME|核算项目名称@,@FNUMBER|核算项目代码@</display_fields>
		<search_fields>@FNAME|核算项目名称@</search_fields>
	</data>
	<data key="feeProduct">
		<description>费用承担产品</description>
		<sql>
			SELECT * FROM t_ICItem
		</sql>
	</data>
	<data key="APPrjItem">
		<description>对方科目、源单类型、往来科目</description>
		<sql>
			SELECT * FROM t_Account
		</sql>
		<display_fields>@FNAME|科目名称@,@FNUMBER|科目代码@</display_fields>
		<search_fields>@FNAME|科目名称@</search_fields>
	</data >
	<data key="accountEntry">
		<description>现金科目</description>
		<sql>
			SELECT * FROM vw_AccountEntry
		</sql>
		<display_fields>@FNUMBER|现金科目代码@,@FNAME|现金科目名称@</display_fields>
		<search_fields>@FNAME|现金科目名称@</search_fields>
	</data>
	<data key="feeRegion">
		<description>费用所属地区</description>
		<sql>
			select * from vw_rp_region
		</sql>
	</data>
	<data key="k3User">
		<description>制单人、审核人</description>
		<sql>
			select u.FUserID,e.FName,u.FName as RoleName,e.FItemID,e.FNumber from t_emp e,t_user u where e.FItemID = u.fempID
		</sql>
	</data>
	<data key="k3Emp">
		<description>申请人</description>
		<sql>
			select * from t_Emp
		</sql>
	</data>

</k3Integrationk3Data>